Select DISTINCT(yr) from (select year(issue_date) as yr, issue_date from color_master,printsize_master,stamps where issue_date!='' and color_master.color_code=stamps.color_code and color_master.color='Plum' and printsize_master.printsize_code=stamps.printsize_code and printsize_master.printsize='3.70 x 2.0' order by issue_date) t